/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50721
 Source Host           : localhost:3306
 Source Schema         : visitor

 Target Server Type    : MySQL
 Target Server Version : 50721
 File Encoding         : 65001

 Date: 15/06/2022 21:35:04
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for smart_user
-- ----------------------------
DROP TABLE IF EXISTS `smart_user`;
CREATE TABLE `smart_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `password` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `mac` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `createTime` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `account` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `headPic` longtext COLLATE utf8_bin,
  `remark` varchar(200) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `account_index` (`account`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of smart_user
-- ----------------------------
BEGIN;
INSERT INTO `smart_user` VALUES (3, 'test', 1, '1', '1', '1', '2020-11-24 23:31:39', 'test', NULL, 'test');
INSERT INTO `smart_user` VALUES (37, 'zhangsan', 22, '13269981099', '123456', '', '2022-12-26 22:50:27', 'zhangsan', '', '');
COMMIT;

-- ----------------------------
-- Table structure for t_admin
-- ----------------------------
DROP TABLE IF EXISTS `t_admin`;
CREATE TABLE `t_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `passwd` varchar(255) DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `createTime` varchar(20) DEFAULT NULL,
  `headPic` longtext,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of t_admin
-- ----------------------------
BEGIN;
INSERT INTO `t_admin` VALUES (24, 'admin', 'admin', 'admin', '2020-11-24 14:10:27', '');
INSERT INTO `t_admin` VALUES (27, 'user', '123456', 'user', '2022-12-26 22:49:47', NULL);
COMMIT;

-- ----------------------------
-- Table structure for videoFlowing
-- ----------------------------
DROP TABLE IF EXISTS `videoFlowing`;
CREATE TABLE `videoFlowing` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `visitorName` varchar(255) DEFAULT NULL,
  `userName` varchar(255) DEFAULT NULL,
  `visitorTime` varchar(255) DEFAULT NULL,
  `visitorPic` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of videoFlowing
-- ----------------------------
BEGIN;
INSERT INTO `videoFlowing` VALUES (1, '李光头', 'zhangsan', '2022-06-16 10', '');
COMMIT;

-- ----------------------------
-- Table structure for visitor
-- ----------------------------
DROP TABLE IF EXISTS `visitor`;
CREATE TABLE `visitor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `visitorName` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `reasons` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `userPhone` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `userName` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `appointmentTime` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `shows` varchar(1) COLLATE utf8_bin DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of visitor
-- ----------------------------
BEGIN;
INSERT INTO `visitor` VALUES (2, 'menghan', '13269981099', '来玩', '13269981099', 'zhangsan', '2022-06-16 10', '1');
COMMIT;

-- ----------------------------
-- Table structure for visitor_record
-- ----------------------------
DROP TABLE IF EXISTS `visitor_record`;
CREATE TABLE `visitor_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `visitorName` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `reasons` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `userPhone` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `userName` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `appointmentTime` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of visitor_record
-- ----------------------------
BEGIN;
INSERT INTO `visitor_record` VALUES (14, '张三', '13269981099', '谈情', '1', 'test', '2021-12-26 00');
INSERT INTO `visitor_record` VALUES (15, 'lisi', '1234567890', '探亲', '13269981099', 'zhangsan', '2021-12-27 00');
INSERT INTO `visitor_record` VALUES (16, 'meng han', '01063601010', '大', '1', 'test', '2022-04-27 09');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
